﻿BEGIN TRANSACTION;
GO

ALTER TABLE [department] DROP CONSTRAINT [FK_department_user_manager_id];
GO

DROP TABLE [material];
GO

DROP TABLE [role_permission];
GO

DROP TABLE [supplier_contact];
GO

DROP TABLE [supplier_qualification];
GO

DROP TABLE [user_role];
GO

DROP TABLE [second_level_category];
GO

DROP TABLE [supplier];
GO

DROP TABLE [role];
GO

DROP TABLE [first_level_category];
GO

DROP TABLE [user];
GO

DROP TABLE [department];
GO

DELETE FROM [__EFMigrationsHistory]
WHERE [MigrationId] = N'20250818075940_InitialCreate';
GO

COMMIT;
GO

